//add fcounty for Louisiana
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
gen fcounty=.
replace fcounty=1 if parish=="Acadia" & state=="Louisiana"
replace fcounty=3 if parish=="Allen" & state=="Louisiana"
replace fcounty=5 if parish=="Ascension" & state=="Louisiana"
replace fcounty=7 if parish=="Assumption" & state=="Louisiana"
replace fcounty=9 if parish=="Avoyelles" & state=="Louisiana"
replace fcounty=11 if parish=="Beauregard" & state=="Louisiana"
replace fcounty=13 if parish=="Bienville" & state=="Louisiana"
replace fcounty=15 if parish=="Bossier" & state=="Louisiana"
replace fcounty=17 if parish=="Caddo" & state=="Louisiana"
replace fcounty=19 if parish=="Calcasieu" & state=="Louisiana"
replace fcounty=21 if parish=="Caldwell" & state=="Louisiana"
replace fcounty=23 if parish=="Cameron" & state=="Louisiana"
replace fcounty=25 if parish=="Catahoula" & state=="Louisiana"
replace fcounty=27 if parish=="Claiborne" & state=="Louisiana"
replace fcounty=29 if parish=="Concordia" & state=="Louisiana"
replace fcounty=31 if parish=="De Soto" & state=="Louisiana"
replace fcounty=33 if parish=="East Baton Rouge" & state=="Louisiana"
replace fcounty=35 if parish=="East Carroll" & state=="Louisiana"
replace fcounty=37 if parish=="East Feliciana" & state=="Louisiana"
replace fcounty=39 if parish=="Evangeline" & state=="Louisiana"
replace fcounty=41 if parish=="Franklin" & state=="Louisiana"
replace fcounty=43 if parish=="Grant" & state=="Louisiana"
replace fcounty=45 if parish=="Iberia" & state=="Louisiana"
replace fcounty=47 if parish=="Iberville" & state=="Louisiana"
replace fcounty=49 if parish=="Jackson" & state=="Louisiana"
replace fcounty=51 if parish=="Jefferson" & state=="Louisiana"
replace fcounty=53 if parish=="Jefferson Davis" & state=="Louisiana"
replace fcounty=55 if parish=="Lafayette" & state=="Louisiana"
replace fcounty=57 if parish=="Lafourche" & state=="Louisiana"
replace fcounty=59 if parish=="La Salle" & state=="Louisiana"
replace fcounty=61 if parish=="Lincoln" & state=="Louisiana"
replace fcounty=63 if parish=="Livingston" & state=="Louisiana"
replace fcounty=65 if parish=="Madison" & state=="Louisiana"
replace fcounty=67 if parish=="Morehouse" & state=="Louisiana"
replace fcounty=69 if parish=="Natchitoches" & state=="Louisiana"
replace fcounty=71 if parish=="Orleans" & state=="Louisiana"
replace fcounty=73 if parish=="Ouachita" & state=="Louisiana"
replace fcounty=75 if parish=="Plaquemines" & state=="Louisiana"
replace fcounty=77 if parish=="Pointe Coupee" & state=="Louisiana"
replace fcounty=79 if parish=="Rapides" & state=="Louisiana"
replace fcounty=81 if parish=="Red River" & state=="Louisiana"
replace fcounty=83 if parish=="Richland" & state=="Louisiana"
replace fcounty=85 if parish=="Sabine" & state=="Louisiana"
replace fcounty=87 if parish=="St Bernard" & state=="Louisiana"
replace fcounty=89 if parish=="St Charles" & state=="Louisiana"
replace fcounty=91 if parish=="St Helena" & state=="Louisiana"
replace fcounty=93 if parish=="St James" & state=="Louisiana"
replace fcounty=95 if parish=="St John the Baptist" & state=="Louisiana"
replace fcounty=97 if parish=="St Landry" & state=="Louisiana"
replace fcounty=99 if parish=="St Martin" & state=="Louisiana"
replace fcounty=101 if parish=="St Mary" & state=="Louisiana"
replace fcounty=103 if parish=="St Tammany" & state=="Louisiana"
replace fcounty=105 if parish=="Tangipahoa" & state=="Louisiana"
replace fcounty=107 if parish=="Tensas" & state=="Louisiana"
replace fcounty=109 if parish=="Terrebonne" & state=="Louisiana"
replace fcounty=111 if parish=="Union" & state=="Louisiana"
replace fcounty=113 if parish=="Vermilion" & state=="Louisiana"
replace fcounty=115 if parish=="Vernon" & state=="Louisiana"
replace fcounty=117 if parish=="Washington" & state=="Louisiana"
replace fcounty=119 if parish=="Webster" & state=="Louisiana"
replace fcounty=121 if parish=="West Baton Rouge" & state=="Louisiana"
replace fcounty=123 if parish=="West Carroll" & state=="Louisiana"
replace fcounty=125 if parish=="West Feliciana" & state=="Louisiana"
replace fcounty=127 if parish=="Winn" & state=="Louisiana"
